insert overwrite table  ODS.DEPB_INFO_HBASE
select
concat(
    -- f_createmd5方法中的参数列表为带除BATCH_DATE字段以外的全部字段
    f_createmd5(ROW_NUM,DATA_DATE,DATA_SRC_ORG,NVL(FIN_DATE,'99999999'),FIN_ORG_NO,FIN_ORG_DIST,BASE_ACCT_NO,SUB_ACCT_NO,DEPOSIT_TYPE,CLIENT_INDUSTRY,CLIENT_DEPARTMENT,NVL(VALUE_DATE,'99999999'),NVL(MATURITY_DATE,'99999999'),CCY,ACTUAL_BAL,IF_FLOAT,RATE)
    ,'_'
    ,DATA_DATE)
,unix_timestamp()
,ROW_NUM
,DATA_DATE
,DATA_SRC_ORG
,NVL(FIN_DATE,'99999999')
,FIN_ORG_NO
,FIN_ORG_DIST
,BASE_ACCT_NO
,SUB_ACCT_NO
,DEPOSIT_TYPE
,CLIENT_INDUSTRY
,CLIENT_DEPARTMENT
,NVL(VALUE_DATE,'99999999')
,NVL(MATURITY_DATE,'99999999')
,CCY
,ACTUAL_BAL
,IF_FLOAT
,RATE
from ODS.DEPB_INFO where data_date in ('\${hiveconf:DATA_DATE}');